Pandas Profiling Report

Dataset statistics

Number of variables	28
Number of observations	119143
Missing cells	20754
Missing cells (%)	0.6%
Duplicate rows	7779
Duplicate rows (%)	6.5%
Total size in memory	30.4 MiB
Average record size in memory	267.5 B

Variable types

Categorical	16
Numeric	12

Alerts

Dataset has 7779 (6.5%) duplicate rows	Duplicates
`order_purchase_timestamp` has a high cardinality: 98875 distinct values	High cardinality
`order_approved_at` has a high cardinality: 90733 distinct values	High cardinality
`order_delivered_carrier_date` has a high cardinality: 81018 distinct values	High cardinality
`order_delivered_customer_date` has a high cardinality: 95664 distinct values	High cardinality
`order_estimated_delivery_date` has a high cardinality: 459 distinct values	High cardinality
`review_creation_date` has a high cardinality: 636 distinct values	High cardinality
`review_answer_timestamp` has a high cardinality: 98248 distinct values	High cardinality
`shipping_limit_date` has a high cardinality: 93318 distinct values	High cardinality
`customer_city` has a high cardinality: 4119 distinct values	High cardinality
`product_category_name_english` has a high cardinality: 72 distinct values	High cardinality
`seller_city` has a high cardinality: 611 distinct values	High cardinality
`payment_value` is highly overall correlated with `price`	High correlation
`price` is highly overall correlated with `payment_value` and 1 other fields	High correlation
`product_weight_g` is highly overall correlated with `price` and 3 other fields	High correlation
`product_length_cm` is highly overall correlated with `product_weight_g` and 1 other fields	High correlation
`product_height_cm` is highly overall correlated with `product_weight_g`	High correlation
`product_width_cm` is highly overall correlated with `product_weight_g` and 1 other fields	High correlation
`order_status` is highly imbalanced (91.6%)	Imbalance
`payment_type` is highly imbalanced (52.6%)	Imbalance
`seller_state` is highly imbalanced (63.3%)	Imbalance
`order_delivered_carrier_date` has 2086 (1.8%) missing values	Missing
`order_delivered_customer_date` has 3421 (2.9%) missing values	Missing
`order_purchase_timestamp` is uniformly distributed	Uniform
`order_approved_at` is uniformly distributed	Uniform
`order_delivered_customer_date` is uniformly distributed	Uniform
`review_answer_timestamp` is uniformly distributed	Uniform
`shipping_limit_date` is uniformly distributed	Uniform
`length_comment_title` has 104159 (87.4%) zeros	Zeros
`length_comment_message` has 67932 (57.0%) zeros	Zeros
`product_description_lenght` has 1709 (1.4%) zeros	Zeros
`product_photos_qty` has 1709 (1.4%) zeros	Zeros

Reproduction

Analysis started	2023-02-08 13:42:44.376976
Analysis finished	2023-02-08 13:43:28.016804
Duration	43.64 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

order_status
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

delivered	115723
shipped	1256
canceled	750
unavailable	652
invoiced	378
Other values (3)	384

Length

Max length	11
Median length	9
Mean length	8.9834401
Min length	7

Characters and Unicode

Total characters	1070314
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	delivered
2nd row	delivered
3rd row	delivered
4th row	delivered
5th row	delivered

Common Values

Value	Count	Frequency (%)
delivered	115723	97.1%
shipped	1256	1.1%
canceled	750	0.6%
unavailable	652	0.5%
invoiced	378	0.3%
processing	376	0.3%
created	5	< 0.1%
approved	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
delivered	115723	97.1%
shipped	1256	1.1%
canceled	750	0.6%
unavailable	652	0.5%
invoiced	378	0.3%
processing	376	0.3%
created	5	< 0.1%
approved	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	351344	32.8%
d	233838	21.8%
i	118763	11.1%
l	117777	11.0%
v	116756	10.9%
r	116107	10.8%
p	2894	0.3%
a	2714	0.3%
c	2259	0.2%
n	2156	0.2%
Other values (7)	5706	0.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1070314	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	351344	32.8%
d	233838	21.8%
i	118763	11.1%
l	117777	11.0%
v	116756	10.9%
r	116107	10.8%
p	2894	0.3%
a	2714	0.3%
c	2259	0.2%
n	2156	0.2%
Other values (7)	5706	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1070314	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	351344	32.8%
d	233838	21.8%
i	118763	11.1%
l	117777	11.0%
v	116756	10.9%
r	116107	10.8%
p	2894	0.3%
a	2714	0.3%
c	2259	0.2%
n	2156	0.2%
Other values (7)	5706	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1070314	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	351344	32.8%
d	233838	21.8%
i	118763	11.1%
l	117777	11.0%
v	116756	10.9%
r	116107	10.8%
p	2894	0.3%
a	2714	0.3%
c	2259	0.2%
n	2156	0.2%
Other values (7)	5706	0.5%

order_purchase_timestamp
Categorical

HIGH CARDINALITY UNIFORM

Distinct	98875
Distinct (%)	83.0%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

2017-08-08 20:26:31	63
2017-09-23 14:56:45	38
2017-04-20 12:45:34	29
2017-06-07 12:05:10	26
2018-05-12 12:28:58	24
Other values (98870)	118963

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2263717
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	85645 ?
Unique (%)	71.9%

Sample

1st row	2017-10-02 10:56:33
2nd row	2017-10-02 10:56:33
3rd row	2017-10-02 10:56:33
4th row	2017-08-15 18:29:31
5th row	2017-08-02 18:24:47

Common Values

Value	Count	Frequency (%)
2017-08-08 20:26:31	63	0.1%
2017-09-23 14:56:45	38	< 0.1%
2017-04-20 12:45:34	29	< 0.1%
2017-06-07 12:05:10	26	< 0.1%
2018-05-12 12:28:58	24	< 0.1%
2018-02-14 16:34:27	24	< 0.1%
2017-07-07 14:55:43	24	< 0.1%
2017-03-09 23:39:26	24	< 0.1%
2017-11-25 13:54:39	24	< 0.1%
2017-12-08 12:00:04	22	< 0.1%
Other values (98865)	118845	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-24	1435	0.6%
2017-11-25	640	0.3%
2017-11-27	508	0.2%
2017-11-26	485	0.2%
2017-11-28	453	0.2%
2018-08-06	445	0.2%
2018-08-07	444	0.2%
2018-05-15	441	0.2%
2018-05-07	430	0.2%
2018-05-14	425	0.2%
Other values (51442)	232580	97.6%

Most occurring characters

Value	Count	Frequency (%)
1	368631	16.3%
0	366708	16.2%
2	290748	12.8%
-	238286	10.5%
:	238286	10.5%
8	123332	5.4%
	119143	5.3%
7	111011	4.9%
3	105264	4.7%
5	96250	4.3%
Other values (3)	206058	9.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1668002	73.7%
Dash Punctuation	238286	10.5%
Other Punctuation	238286	10.5%
Space Separator	119143	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	368631	22.1%
0	366708	22.0%
2	290748	17.4%
8	123332	7.4%
7	111011	6.7%
3	105264	6.3%
5	96250	5.8%
4	96104	5.8%
6	56686	3.4%
9	53268	3.2%

Dash Punctuation

Value	Count	Frequency (%)
-	238286	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	238286	100.0%

Space Separator

Value	Count	Frequency (%)
	119143	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2263717	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	368631	16.3%
0	366708	16.2%
2	290748	12.8%
-	238286	10.5%
:	238286	10.5%
8	123332	5.4%
	119143	5.3%
7	111011	4.9%
3	105264	4.7%
5	96250	4.3%
Other values (3)	206058	9.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2263717	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	368631	16.3%
0	366708	16.2%
2	290748	12.8%
-	238286	10.5%
:	238286	10.5%
8	123332	5.4%
	119143	5.3%
7	111011	4.9%
3	105264	4.7%
5	96250	4.3%
Other values (3)	206058	9.1%

order_approved_at
Categorical

HIGH CARDINALITY UNIFORM

Distinct	90733
Distinct (%)	76.3%
Missing	177
Missing (%)	0.1%
Memory size	1.8 MiB

2017-08-08 20:43:31	63
2017-09-25 17:44:41	38
2017-04-22 09:10:13	29
2017-06-09 16:15:08	26
2017-03-09 23:39:26	24
Other values (90728)	118786

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2260354
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	72654 ?
Unique (%)	61.1%

Sample

1st row	2017-10-02 11:07:15
2nd row	2017-10-02 11:07:15
3rd row	2017-10-02 11:07:15
4th row	2017-08-15 20:05:16
5th row	2017-08-02 18:43:15

Common Values

Value	Count	Frequency (%)
2017-08-08 20:43:31	63	0.1%
2017-09-25 17:44:41	38	< 0.1%
2017-04-22 09:10:13	29	< 0.1%
2017-06-09 16:15:08	26	< 0.1%
2017-03-09 23:39:26	24	< 0.1%
2018-05-12 15:41:58	24	< 0.1%
2017-07-07 15:10:17	24	< 0.1%
2018-02-21 12:28:15	24	< 0.1%
2017-11-25 14:16:34	24	< 0.1%
2018-02-24 03:20:27	23	< 0.1%
Other values (90723)	118667	99.6%
(Missing)	177	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-04-24	1163	0.5%
2017-11-24	1000	0.4%
2017-11-25	943	0.4%
2018-07-05	825	0.3%
2017-11-28	607	0.3%
2018-08-07	505	0.2%
2018-05-08	498	0.2%
2018-01-22	489	0.2%
2018-08-20	488	0.2%
2018-05-01	487	0.2%
Other values (42347)	230927	97.1%

Most occurring characters

Value	Count	Frequency (%)
0	381200	16.9%
1	366273	16.2%
2	289265	12.8%
-	237932	10.5%
:	237932	10.5%
	118966	5.3%
8	116954	5.2%
5	114527	5.1%
3	111559	4.9%
7	105817	4.7%
Other values (3)	179929	8.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1665524	73.7%
Dash Punctuation	237932	10.5%
Other Punctuation	237932	10.5%
Space Separator	118966	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	381200	22.9%
1	366273	22.0%
2	289265	17.4%
8	116954	7.0%
5	114527	6.9%
3	111559	6.7%
7	105817	6.4%
4	82414	4.9%
6	51368	3.1%
9	46147	2.8%

Dash Punctuation

Value	Count	Frequency (%)
-	237932	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	237932	100.0%

Space Separator

Value	Count	Frequency (%)
	118966	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2260354	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	381200	16.9%
1	366273	16.2%
2	289265	12.8%
-	237932	10.5%
:	237932	10.5%
	118966	5.3%
8	116954	5.2%
5	114527	5.1%
3	111559	4.9%
7	105817	4.7%
Other values (3)	179929	8.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2260354	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	381200	16.9%
1	366273	16.2%
2	289265	12.8%
-	237932	10.5%
:	237932	10.5%
	118966	5.3%
8	116954	5.2%
5	114527	5.1%
3	111559	4.9%
7	105817	4.7%
Other values (3)	179929	8.0%

order_delivered_carrier_date
Categorical

HIGH CARDINALITY MISSING

Distinct	81018
Distinct (%)	69.2%
Missing	2086
Missing (%)	1.8%
Memory size	1.8 MiB

2017-08-10 11:58:14	63
2018-05-09 15:48:00	48
2017-10-02 23:47:54	38
2018-05-10 18:29:00	36
2018-05-14 14:25:00	32
Other values (81013)	116840

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2224083
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	61382 ?
Unique (%)	52.4%

Sample

1st row	2017-10-04 19:55:00
2nd row	2017-10-04 19:55:00
3rd row	2017-10-04 19:55:00
4th row	2017-08-17 15:28:33
5th row	2017-08-04 17:35:43

Common Values

Value	Count	Frequency (%)
2017-08-10 11:58:14	63	0.1%
2018-05-09 15:48:00	48	< 0.1%
2017-10-02 23:47:54	38	< 0.1%
2018-05-10 18:29:00	36	< 0.1%
2018-05-14 14:25:00	32	< 0.1%
2017-04-24 11:31:17	29	< 0.1%
2018-05-04 15:46:00	29	< 0.1%
2018-08-08 15:01:00	27	< 0.1%
2017-06-16 15:50:28	26	< 0.1%
2018-06-13 14:13:00	24	< 0.1%
Other values (81008)	116705	98.0%
(Missing)	2086	1.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-28	925	0.4%
2017-11-27	818	0.3%
2017-11-29	706	0.3%
2018-02-27	632	0.3%
2018-03-27	622	0.3%
2018-08-06	595	0.3%
2017-11-30	584	0.2%
2018-05-14	568	0.2%
2018-08-13	550	0.2%
2018-05-03	539	0.2%
Other values (37539)	227575	97.2%

Most occurring characters

Value	Count	Frequency (%)
0	405304	18.2%
1	346875	15.6%
2	275757	12.4%
-	234114	10.5%
:	234114	10.5%
8	123405	5.5%
	117057	5.3%
7	106647	4.8%
3	98637	4.4%
4	92061	4.1%
Other values (3)	190112	8.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1638798	73.7%
Dash Punctuation	234114	10.5%
Other Punctuation	234114	10.5%
Space Separator	117057	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	405304	24.7%
1	346875	21.2%
2	275757	16.8%
8	123405	7.5%
7	106647	6.5%
3	98637	6.0%
4	92061	5.6%
5	89897	5.5%
6	51437	3.1%
9	48778	3.0%

Dash Punctuation

Value	Count	Frequency (%)
-	234114	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	234114	100.0%

Space Separator

Value	Count	Frequency (%)
	117057	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2224083	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	405304	18.2%
1	346875	15.6%
2	275757	12.4%
-	234114	10.5%
:	234114	10.5%
8	123405	5.5%
	117057	5.3%
7	106647	4.8%
3	98637	4.4%
4	92061	4.1%
Other values (3)	190112	8.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2224083	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	405304	18.2%
1	346875	15.6%
2	275757	12.4%
-	234114	10.5%
:	234114	10.5%
8	123405	5.5%
	117057	5.3%
7	106647	4.8%
3	98637	4.4%
4	92061	4.1%
Other values (3)	190112	8.5%

order_delivered_customer_date
Categorical

HIGH CARDINALITY MISSING UNIFORM

Distinct	95664
Distinct (%)	82.7%
Missing	3421
Missing (%)	2.9%
Memory size	1.8 MiB

2017-08-14 12:46:18	63
2017-10-18 22:35:50	38
2017-06-22 16:04:46	26
2017-11-30 14:59:18	24
2018-02-28 20:09:19	24
Other values (95659)	115547

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2198718
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	82390 ?
Unique (%)	71.2%

Sample

1st row	2017-10-10 21:25:13
2nd row	2017-10-10 21:25:13
3rd row	2017-10-10 21:25:13
4th row	2017-08-18 14:44:43
5th row	2017-08-07 18:30:01

Common Values

Value	Count	Frequency (%)
2017-08-14 12:46:18	63	0.1%
2017-10-18 22:35:50	38	< 0.1%
2017-06-22 16:04:46	26	< 0.1%
2017-11-30 14:59:18	24	< 0.1%
2018-02-28 20:09:19	24	< 0.1%
2017-07-27 20:52:15	24	< 0.1%
2017-03-21 13:32:45	24	< 0.1%
2018-06-01 15:18:45	24	< 0.1%
2017-12-21 16:33:10	22	< 0.1%
2017-10-22 14:43:54	22	< 0.1%
Other values (95654)	115431	96.9%
(Missing)	3421	2.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-05-21	529	0.2%
2018-05-14	528	0.2%
2018-08-13	507	0.2%
2018-05-18	505	0.2%
2018-08-27	504	0.2%
2018-05-03	501	0.2%
2018-04-11	495	0.2%
2017-12-11	489	0.2%
2017-12-19	484	0.2%
2017-06-19	482	0.2%
Other values (41734)	226420	97.8%

Most occurring characters

Value	Count	Frequency (%)
1	340122	15.5%
0	336673	15.3%
2	291213	13.2%
-	231444	10.5%
:	231444	10.5%
8	135442	6.2%
	115722	5.3%
7	107273	4.9%
3	107058	4.9%
4	100137	4.6%
Other values (3)	202190	9.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1620108	73.7%
Dash Punctuation	231444	10.5%
Other Punctuation	231444	10.5%
Space Separator	115722	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	340122	21.0%
0	336673	20.8%
2	291213	18.0%
8	135442	8.4%
7	107273	6.6%
3	107058	6.6%
4	100137	6.2%
5	93750	5.8%
6	58489	3.6%
9	49951	3.1%

Dash Punctuation

Value	Count	Frequency (%)
-	231444	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	231444	100.0%

Space Separator

Value	Count	Frequency (%)
	115722	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2198718	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	340122	15.5%
0	336673	15.3%
2	291213	13.2%
-	231444	10.5%
:	231444	10.5%
8	135442	6.2%
	115722	5.3%
7	107273	4.9%
3	107058	4.9%
4	100137	4.6%
Other values (3)	202190	9.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2198718	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	340122	15.5%
0	336673	15.3%
2	291213	13.2%
-	231444	10.5%
:	231444	10.5%
8	135442	6.2%
	115722	5.3%
7	107273	4.9%
3	107058	4.9%
4	100137	4.6%
Other values (3)	202190	9.2%

order_estimated_delivery_date
Categorical

Distinct	459
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

2017-12-20 00:00:00	663
2018-03-13 00:00:00	620
2018-03-12 00:00:00	618
2018-05-29 00:00:00	612
2018-05-30 00:00:00	591
Other values (454)	116039

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2263717
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19 ?
Unique (%)	< 0.1%

Sample

1st row	2017-10-18 00:00:00
2nd row	2017-10-18 00:00:00
3rd row	2017-10-18 00:00:00
4th row	2017-08-28 00:00:00
5th row	2017-08-15 00:00:00

Common Values

Value	Count	Frequency (%)
2017-12-20 00:00:00	663	0.6%
2018-03-13 00:00:00	620	0.5%
2018-03-12 00:00:00	618	0.5%
2018-05-29 00:00:00	612	0.5%
2018-05-30 00:00:00	591	0.5%
2018-02-14 00:00:00	590	0.5%
2018-07-16 00:00:00	590	0.5%
2018-07-05 00:00:00	588	0.5%
2018-02-06 00:00:00	587	0.5%
2017-12-19 00:00:00	587	0.5%
Other values (449)	113097	94.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	119143	50.0%
2017-12-20	663	0.3%
2018-03-13	620	0.3%
2018-03-12	618	0.3%
2018-05-29	612	0.3%
2018-05-30	591	0.2%
2018-02-14	590	0.2%
2018-07-16	590	0.2%
2018-07-05	588	0.2%
2018-02-06	587	0.2%
Other values (450)	113684	47.7%

Most occurring characters

Value	Count	Frequency (%)
0	985406	43.5%
-	238286	10.5%
:	238286	10.5%
1	204158	9.0%
2	185778	8.2%
	119143	5.3%
8	98222	4.3%
7	72819	3.2%
3	31950	1.4%
5	24449	1.1%
Other values (3)	65220	2.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1668002	73.7%
Dash Punctuation	238286	10.5%
Other Punctuation	238286	10.5%
Space Separator	119143	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	985406	59.1%
1	204158	12.2%
2	185778	11.1%
8	98222	5.9%
7	72819	4.4%
3	31950	1.9%
5	24449	1.5%
6	23221	1.4%
4	22239	1.3%
9	19760	1.2%

Dash Punctuation

Value	Count	Frequency (%)
-	238286	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	238286	100.0%

Space Separator

Value	Count	Frequency (%)
	119143	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2263717	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	985406	43.5%
-	238286	10.5%
:	238286	10.5%
1	204158	9.0%
2	185778	8.2%
	119143	5.3%
8	98222	4.3%
7	72819	3.2%
3	31950	1.4%
5	24449	1.1%
Other values (3)	65220	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2263717	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	985406	43.5%
-	238286	10.5%
:	238286	10.5%
1	204158	9.0%
2	185778	8.2%
	119143	5.3%
8	98222	4.3%
7	72819	3.2%
3	31950	1.4%
5	24449	1.1%
Other values (3)	65220	2.9%

review_score
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	997
Missing (%)	0.8%
Memory size	1.8 MiB

5.0	66343
4.0	22319
1.0	15428
3.0	9894
2.0	4162

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	354438
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4.0
2nd row	4.0
3rd row	4.0
4th row	4.0
5th row	5.0

Common Values

Value	Count	Frequency (%)
5.0	66343	55.7%
4.0	22319	18.7%
1.0	15428	12.9%
3.0	9894	8.3%
2.0	4162	3.5%
(Missing)	997	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5.0	66343	56.2%
4.0	22319	18.9%
1.0	15428	13.1%
3.0	9894	8.4%
2.0	4162	3.5%

Most occurring characters

Value	Count	Frequency (%)
.	118146	33.3%
0	118146	33.3%
5	66343	18.7%
4	22319	6.3%
1	15428	4.4%
3	9894	2.8%
2	4162	1.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	236292	66.7%
Other Punctuation	118146	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	118146	50.0%
5	66343	28.1%
4	22319	9.4%
1	15428	6.5%
3	9894	4.2%
2	4162	1.8%

Other Punctuation

Value	Count	Frequency (%)
.	118146	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	354438	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	118146	33.3%
0	118146	33.3%
5	66343	18.7%
4	22319	6.3%
1	15428	4.4%
3	9894	2.8%
2	4162	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	354438	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	118146	33.3%
0	118146	33.3%
5	66343	18.7%
4	22319	6.3%
1	15428	4.4%
3	9894	2.8%
2	4162	1.2%

review_creation_date
Categorical

Distinct	636
Distinct (%)	0.5%
Missing	997
Missing (%)	0.8%
Memory size	1.8 MiB

2017-12-19 00:00:00	547
2018-05-22 00:00:00	521
2018-05-15 00:00:00	517
2017-12-20 00:00:00	515
2018-05-19 00:00:00	509
Other values (631)	115537

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2244774
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	26 ?
Unique (%)	< 0.1%

Sample

1st row	2017-10-11 00:00:00
2nd row	2017-10-11 00:00:00
3rd row	2017-10-11 00:00:00
4th row	2017-08-19 00:00:00
5th row	2017-08-08 00:00:00

Common Values

Value	Count	Frequency (%)
2017-12-19 00:00:00	547	0.5%
2018-05-22 00:00:00	521	0.4%
2018-05-15 00:00:00	517	0.4%
2017-12-20 00:00:00	515	0.4%
2018-05-19 00:00:00	509	0.4%
2018-08-28 00:00:00	507	0.4%
2018-03-29 00:00:00	504	0.4%
2018-05-04 00:00:00	504	0.4%
2018-04-12 00:00:00	486	0.4%
2018-03-30 00:00:00	485	0.4%
Other values (626)	113051	94.9%
(Missing)	997	0.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	118049	50.0%
2017-12-19	547	0.2%
2018-05-22	521	0.2%
2018-05-15	517	0.2%
2017-12-20	515	0.2%
2018-05-19	509	0.2%
2018-08-28	507	0.2%
2018-03-29	504	0.2%
2018-05-04	504	0.2%
2018-04-12	486	0.2%
Other values (628)	113633	48.1%

Most occurring characters

Value	Count	Frequency (%)
0	973738	43.4%
-	236292	10.5%
:	236292	10.5%
1	205175	9.1%
2	188753	8.4%
	118146	5.3%
8	94367	4.2%
7	74321	3.3%
3	29057	1.3%
5	25233	1.1%
Other values (3)	63400	2.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1654044	73.7%
Dash Punctuation	236292	10.5%
Other Punctuation	236292	10.5%
Space Separator	118146	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	973738	58.9%
1	205175	12.4%
2	188753	11.4%
8	94367	5.7%
7	74321	4.5%
3	29057	1.8%
5	25233	1.5%
4	23694	1.4%
6	23414	1.4%
9	16292	1.0%

Dash Punctuation

Value	Count	Frequency (%)
-	236292	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	236292	100.0%

Space Separator

Value	Count	Frequency (%)
	118146	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2244774	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	973738	43.4%
-	236292	10.5%
:	236292	10.5%
1	205175	9.1%
2	188753	8.4%
	118146	5.3%
8	94367	4.2%
7	74321	3.3%
3	29057	1.3%
5	25233	1.1%
Other values (3)	63400	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2244774	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	973738	43.4%
-	236292	10.5%
:	236292	10.5%
1	205175	9.1%
2	188753	8.4%
	118146	5.3%
8	94367	4.2%
7	74321	3.3%
3	29057	1.3%
5	25233	1.1%
Other values (3)	63400	2.8%

review_answer_timestamp
Categorical

HIGH CARDINALITY UNIFORM

Distinct	98248
Distinct (%)	83.2%
Missing	997
Missing (%)	0.8%
Memory size	1.8 MiB

2017-08-17 22:17:55	63
2017-10-19 21:08:44	38
2017-05-24 16:21:27	29
2017-06-28 18:49:50	26
2018-03-07 15:08:10	24
Other values (98243)	117966

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2244774
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	85133 ?
Unique (%)	72.1%

Sample

1st row	2017-10-12 03:43:48
2nd row	2017-10-12 03:43:48
3rd row	2017-10-12 03:43:48
4th row	2017-08-20 15:16:36
5th row	2017-08-08 23:26:23

Common Values

Value	Count	Frequency (%)
2017-08-17 22:17:55	63	0.1%
2017-10-19 21:08:44	38	< 0.1%
2017-05-24 16:21:27	29	< 0.1%
2017-06-28 18:49:50	26	< 0.1%
2018-03-07 15:08:10	24	< 0.1%
2018-06-04 19:04:20	24	< 0.1%
2017-03-23 08:34:13	24	< 0.1%
2017-08-01 13:20:31	24	< 0.1%
2017-12-22 20:33:52	22	< 0.1%
2018-02-19 20:04:36	21	< 0.1%
Other values (98238)	117851	98.9%
(Missing)	997	0.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-05-20	781	0.3%
2018-05-21	684	0.3%
2018-05-10	593	0.3%
2017-12-20	472	0.2%
2018-04-13	432	0.2%
2017-12-13	421	0.2%
2017-12-22	421	0.2%
2018-08-24	418	0.2%
2018-05-11	414	0.2%
2017-12-21	412	0.2%
Other values (53983)	231244	97.9%

Most occurring characters

Value	Count	Frequency (%)
0	378113	16.8%
1	350346	15.6%
2	299408	13.3%
-	236292	10.5%
:	236292	10.5%
8	124163	5.5%
	118146	5.3%
3	109822	4.9%
7	102251	4.6%
5	93511	4.2%
Other values (3)	196430	8.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1654044	73.7%
Dash Punctuation	236292	10.5%
Other Punctuation	236292	10.5%
Space Separator	118146	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	378113	22.9%
1	350346	21.2%
2	299408	18.1%
8	124163	7.5%
3	109822	6.6%
7	102251	6.2%
5	93511	5.7%
4	93373	5.6%
6	53342	3.2%
9	49715	3.0%

Dash Punctuation

Value	Count	Frequency (%)
-	236292	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	236292	100.0%

Space Separator

Value	Count	Frequency (%)
	118146	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2244774	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	378113	16.8%
1	350346	15.6%
2	299408	13.3%
-	236292	10.5%
:	236292	10.5%
8	124163	5.5%
	118146	5.3%
3	109822	4.9%
7	102251	4.6%
5	93511	4.2%
Other values (3)	196430	8.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2244774	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	378113	16.8%
1	350346	15.6%
2	299408	13.3%
-	236292	10.5%
:	236292	10.5%
8	124163	5.5%
	118146	5.3%
3	109822	4.9%
7	102251	4.6%
5	93511	4.2%
Other values (3)	196430	8.8%

length_comment_title
Real number (ℝ)

Distinct	27
Distinct (%)	< 0.1%
Missing	997
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	1.4256682

Minimum	0
Maximum	26
Zeros	104159
Zeros (%)	87.4%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	13
Maximum	26
Range	26
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	4.4658155
Coefficient of variation (CV)	3.1324367
Kurtosis	11.168711
Mean	1.4256682
Median Absolute Deviation (MAD)	0
Skewness	3.3991733
Sum	168437
Variance	19.943508
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
0	104159	87.4%
9	2347	2.0%
5	1259	1.1%
15	1041	0.9%
3	804	0.7%
10	685	0.6%
13	618	0.5%
17	616	0.5%
25	575	0.5%
16	528	0.4%
Other values (17)	5514	4.6%
(Missing)	997	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	104159	87.4%
1	191	0.2%
2	300	0.3%
3	804	0.7%
4	226	0.2%
5	1259	1.1%
6	282	0.2%
7	450	0.4%
8	407	0.3%
9	2347	2.0%

Value	Count	Frequency (%)
26	2	< 0.1%
25	575	0.5%
24	299	0.3%
23	253	0.2%
22	265	0.2%
21	319	0.3%
20	484	0.4%
19	331	0.3%
18	413	0.3%
17	616	0.5%

length_comment_message
Real number (ℝ)

Distinct	209
Distinct (%)	0.2%
Missing	997
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	29.929579

Minimum	0
Maximum	208
Zeros	67932
Zeros (%)	57.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	44
95-th percentile	154
Maximum	208
Range	208
Interquartile range (IQR)	44

Descriptive statistics

Standard deviation	49.834722
Coefficient of variation (CV)	1.6650659
Kurtosis	2.8705156
Mean	29.929579
Median Absolute Deviation (MAD)	0
Skewness	1.8936024
Sum	3536060
Variance	2483.4995
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	67932	57.0%
9	1144	1.0%
200	806	0.7%
5	651	0.5%
26	617	0.5%
10	594	0.5%
20	584	0.5%
3	571	0.5%
30	561	0.5%
35	547	0.5%
Other values (199)	44139	37.0%
(Missing)	997	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	67932	57.0%
1	109	0.1%
2	233	0.2%
3	571	0.5%
4	129	0.1%
5	651	0.5%
6	214	0.2%
7	285	0.2%
8	294	0.2%
9	1144	1.0%

Value	Count	Frequency (%)
208	1	< 0.1%
207	1	< 0.1%
206	1	< 0.1%
205	1	< 0.1%
204	17	< 0.1%
203	21	< 0.1%
202	20	< 0.1%
201	29	< 0.1%
200	806	0.7%
199	452	0.4%

payment_type
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	3
Missing (%)	< 0.1%
Memory size	1.8 MiB

credit_card	87776
boleto	23190
voucher	6465
debit_card	1706
not_defined	3

Length

Max length	11
Median length	11
Mean length	9.7954004
Min length	6

Characters and Unicode

Total characters	1167024
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	credit_card
2nd row	voucher
3rd row	voucher
4th row	credit_card
5th row	credit_card

Common Values

Value	Count	Frequency (%)
credit_card	87776	73.7%
boleto	23190	19.5%
voucher	6465	5.4%
debit_card	1706	1.4%
not_defined	3	< 0.1%
(Missing)	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
credit_card	87776	73.7%
boleto	23190	19.5%
voucher	6465	5.4%
debit_card	1706	1.4%
not_defined	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
c	183723	15.7%
r	183723	15.7%
d	178970	15.3%
e	119143	10.2%
t	112675	9.7%
i	89485	7.7%
_	89485	7.7%
a	89482	7.7%
o	52848	4.5%
b	24896	2.1%
Other values (6)	42594	3.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1077539	92.3%
Connector Punctuation	89485	7.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
c	183723	17.1%
r	183723	17.1%
d	178970	16.6%
e	119143	11.1%
t	112675	10.5%
i	89485	8.3%
a	89482	8.3%
o	52848	4.9%
b	24896	2.3%
l	23190	2.2%
Other values (5)	19404	1.8%

Connector Punctuation

Value	Count	Frequency (%)
_	89485	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1077539	92.3%
Common	89485	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
c	183723	17.1%
r	183723	17.1%
d	178970	16.6%
e	119143	11.1%
t	112675	10.5%
i	89485	8.3%
a	89482	8.3%
o	52848	4.9%
b	24896	2.3%
l	23190	2.2%
Other values (5)	19404	1.8%

Common

Value	Count	Frequency (%)
_	89485	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1167024	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
c	183723	15.7%
r	183723	15.7%
d	178970	15.3%
e	119143	10.2%
t	112675	9.7%
i	89485	7.7%
_	89485	7.7%
a	89482	7.7%
o	52848	4.5%
b	24896	2.1%
Other values (6)	42594	3.6%

payment_installments
Real number (ℝ)

Distinct	24
Distinct (%)	< 0.1%
Missing	3
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.9412456

Minimum	0
Maximum	24
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	10
Maximum	24
Range	24
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.7778477
Coefficient of variation (CV)	0.94444604
Kurtosis	2.5065453
Mean	2.9412456
Median Absolute Deviation (MAD)	1
Skewness	1.6198199
Sum	350420
Variance	7.7164381
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
1	59446	49.9%
2	13838	11.6%
3	11889	10.0%
4	8072	6.8%
10	6976	5.9%
5	6097	5.1%
8	5120	4.3%
6	4674	3.9%
7	1848	1.6%
9	739	0.6%
Other values (14)	441	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	< 0.1%
1	59446	49.9%
2	13838	11.6%
3	11889	10.0%
4	8072	6.8%
5	6097	5.1%
6	4674	3.9%
7	1848	1.6%
8	5120	4.3%
9	739	0.6%

Value	Count	Frequency (%)
24	34	< 0.1%
23	1	< 0.1%
22	1	< 0.1%
21	6	< 0.1%
20	21	< 0.1%
18	38	< 0.1%
17	8	< 0.1%
16	7	< 0.1%
15	93	0.1%
14	16	< 0.1%

payment_value
Real number (ℝ)

Distinct	29077
Distinct (%)	24.4%
Missing	3
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	172.73514

Minimum	0
Maximum	13664.08
Zeros	9
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	27.1
Q1	60.85
median	108.16
Q3	189.24
95-th percentile	515.93
Maximum	13664.08
Range	13664.08
Interquartile range (IQR)	128.39

Descriptive statistics

Standard deviation	267.77608
Coefficient of variation (CV)	1.550212
Kurtosis	500.3632
Mean	172.73514
Median Absolute Deviation (MAD)	56.64
Skewness	13.965989
Sum	20579664
Variance	71704.027
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	351	0.3%
100	300	0.3%
20	286	0.2%
77.57	250	0.2%
35	166	0.1%
73.34	160	0.1%
30	139	0.1%
116.94	133	0.1%
56.78	123	0.1%
107.78	120	0.1%
Other values (29067)	117112	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9	< 0.1%
0.01	6	< 0.1%
0.03	2	< 0.1%
0.05	2	< 0.1%
0.07	1	< 0.1%
0.08	2	< 0.1%
0.09	1	< 0.1%
0.1	3	< 0.1%
0.11	2	< 0.1%
0.13	2	< 0.1%

Value	Count	Frequency (%)
13664.08	8	< 0.1%
7274.88	4	< 0.1%
6929.31	1	< 0.1%
6922.21	1	< 0.1%
6726.66	1	< 0.1%
6081.54	6	< 0.1%
4950.34	1	< 0.1%
4809.44	2	< 0.1%
4764.34	1	< 0.1%
4681.78	1	< 0.1%

shipping_limit_date
Categorical

HIGH CARDINALITY UNIFORM

Distinct	93318
Distinct (%)	78.9%
Missing	833
Missing (%)	0.7%
Memory size	1.8 MiB

2017-08-14 20:43:31	63
2017-10-05 17:44:41	38
2017-04-27 09:10:13	29
2017-06-15 16:15:08	26
2017-11-30 14:16:34	24
Other values (93313)	118130

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	2247890
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	76920 ?
Unique (%)	65.0%

Sample

1st row	2017-10-06 11:07:15
2nd row	2017-10-06 11:07:15
3rd row	2017-10-06 11:07:15
4th row	2017-08-21 20:05:16
5th row	2017-08-08 18:37:31

Common Values

Value	Count	Frequency (%)
2017-08-14 20:43:31	63	0.1%
2017-10-05 17:44:41	38	< 0.1%
2017-04-27 09:10:13	29	< 0.1%
2017-06-15 16:15:08	26	< 0.1%
2017-11-30 14:16:34	24	< 0.1%
2018-05-15 15:30:28	24	< 0.1%
2018-02-27 12:28:15	24	< 0.1%
2017-07-13 15:10:17	24	< 0.1%
2017-03-15 23:39:26	24	< 0.1%
2017-10-24 13:06:21	22	< 0.1%
Other values (93308)	118012	99.1%
(Missing)	833	0.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-30	1753	0.7%
2017-12-07	794	0.3%
2018-04-19	729	0.3%
2018-05-10	696	0.3%
2018-01-18	689	0.3%
2018-03-08	681	0.3%
2018-08-07	678	0.3%
2018-02-22	673	0.3%
2018-03-22	670	0.3%
2018-03-01	663	0.3%
Other values (40675)	228594	96.6%

Most occurring characters

Value	Count	Frequency (%)
0	379298	16.9%
1	364436	16.2%
2	289766	12.9%
-	236620	10.5%
:	236620	10.5%
8	118667	5.3%
	118310	5.3%
3	114161	5.1%
5	111987	5.0%
7	102121	4.5%
Other values (3)	175904	7.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1656340	73.7%
Dash Punctuation	236620	10.5%
Other Punctuation	236620	10.5%
Space Separator	118310	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	379298	22.9%
1	364436	22.0%
2	289766	17.5%
8	118667	7.2%
3	114161	6.9%
5	111987	6.8%
7	102121	6.2%
4	79394	4.8%
6	49607	3.0%
9	46903	2.8%

Dash Punctuation

Value	Count	Frequency (%)
-	236620	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	236620	100.0%

Space Separator

Value	Count	Frequency (%)
	118310	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2247890	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	379298	16.9%
1	364436	16.2%
2	289766	12.9%
-	236620	10.5%
:	236620	10.5%
8	118667	5.3%
	118310	5.3%
3	114161	5.1%
5	111987	5.0%
7	102121	4.5%
Other values (3)	175904	7.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2247890	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	379298	16.9%
1	364436	16.2%
2	289766	12.9%
-	236620	10.5%
:	236620	10.5%
8	118667	5.3%
	118310	5.3%
3	114161	5.1%
5	111987	5.0%
7	102121	4.5%
Other values (3)	175904	7.8%

price
Real number (ℝ)

Distinct	5968
Distinct (%)	5.0%
Missing	833
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	120.6466

Minimum	0.85
Maximum	6735
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0.85
5-th percentile	17
Q1	39.9
median	74.9
Q3	134.9
95-th percentile	349.9
Maximum	6735
Range	6734.15
Interquartile range (IQR)	95

Descriptive statistics

Standard deviation	184.10969
Coefficient of variation (CV)	1.5260247
Kurtosis	119.15494
Mean	120.6466
Median Absolute Deviation (MAD)	42
Skewness	7.8925735
Sum	14273700
Variance	33896.378
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.9	2619	2.2%
69.9	2113	1.8%
49.9	2051	1.7%
89.9	1644	1.4%
99.9	1526	1.3%
39.9	1403	1.2%
29.9	1387	1.2%
19.9	1284	1.1%
79.9	1282	1.1%
29.99	1228	1.0%
Other values (5958)	101773	85.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.85	3	< 0.1%
1.2	20	< 0.1%
2.2	2	< 0.1%
2.29	1	< 0.1%
2.9	1	< 0.1%
2.99	1	< 0.1%
3	2	< 0.1%
3.06	3	< 0.1%
3.49	3	< 0.1%
3.5	7	< 0.1%

Value	Count	Frequency (%)
6735	1	< 0.1%
6729	1	< 0.1%
6499	1	< 0.1%
4799	1	< 0.1%
4690	1	< 0.1%
4590	1	< 0.1%
4399.87	1	< 0.1%
4099.99	1	< 0.1%
4059	1	< 0.1%
3999.9	1	< 0.1%

freight_value
Real number (ℝ)

Distinct	6999
Distinct (%)	5.9%
Missing	833
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	20.032387

Minimum	0
Maximum	409.68
Zeros	390
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	7.78
Q1	13.08
median	16.28
Q3	21.18
95-th percentile	45.3
Maximum	409.68
Range	409.68
Interquartile range (IQR)	8.1

Descriptive statistics

Standard deviation	15.83685
Coefficient of variation (CV)	0.79056234
Kurtosis	57.635327
Mean	20.032387
Median Absolute Deviation (MAD)	3.63
Skewness	5.5433839
Sum	2370031.6
Variance	250.80583
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.1	3861	3.2%
7.78	2355	2.0%
11.85	1999	1.7%
14.1	1992	1.7%
18.23	1632	1.4%
7.39	1573	1.3%
16.11	1211	1.0%
15.23	1064	0.9%
8.72	970	0.8%
16.79	930	0.8%
Other values (6989)	100723	84.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	390	0.3%
0.01	4	< 0.1%
0.02	3	< 0.1%
0.03	14	< 0.1%
0.04	4	< 0.1%
0.05	9	< 0.1%
0.06	13	< 0.1%
0.07	1	< 0.1%
0.08	12	< 0.1%
0.09	6	< 0.1%

Value	Count	Frequency (%)
409.68	1	< 0.1%
375.28	2	< 0.1%
339.59	1	< 0.1%
338.3	1	< 0.1%
322.1	1	< 0.1%
321.88	1	< 0.1%
321.46	1	< 0.1%
317.47	1	< 0.1%
314.4	1	< 0.1%
314.02	1	< 0.1%

customer_city
Categorical

Distinct	4119
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

sao paulo	18875
rio de janeiro	8311
belo horizonte	3299
brasilia	2500
curitiba	1827
Other values (4114)	84331

Length

Max length	32
Median length	27
Mean length	10.33532
Min length	3

Characters and Unicode

Total characters	1231381
Distinct characters	31
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1036 ?
Unique (%)	0.9%

Sample

1st row	sao paulo
2nd row	sao paulo
3rd row	sao paulo
4th row	sao paulo
5th row	sao paulo

Common Values

Value	Count	Frequency (%)
sao paulo	18875	15.8%
rio de janeiro	8311	7.0%
belo horizonte	3299	2.8%
brasilia	2500	2.1%
curitiba	1827	1.5%
campinas	1757	1.5%
porto alegre	1675	1.4%
salvador	1544	1.3%
guarulhos	1415	1.2%
sao bernardo do campo	1131	0.9%
Other values (4109)	76809	64.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sao	25445	12.2%
paulo	18957	9.1%
de	11657	5.6%
rio	9967	4.8%
janeiro	8311	4.0%
do	5095	2.4%
belo	3373	1.6%
horizonte	3327	1.6%
brasilia	2510	1.2%
porto	1998	1.0%
Other values (3285)	118347	56.6%

Most occurring characters

Value	Count	Frequency (%)
a	203082	16.5%
o	151991	12.3%
i	94150	7.6%
r	91236	7.4%
	89844	7.3%
e	79953	6.5%
s	75446	6.1%
n	54566	4.4%
u	54064	4.4%
l	53676	4.4%
Other values (21)	283373	23.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1140982	92.7%
Space Separator	89844	7.3%
Dash Punctuation	290	< 0.1%
Other Punctuation	263	< 0.1%
Decimal Number	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	203082	17.8%
o	151991	13.3%
i	94150	8.3%
r	91236	8.0%
e	79953	7.0%
s	75446	6.6%
n	54566	4.8%
u	54064	4.7%
l	53676	4.7%
p	44782	3.9%
Other values (16)	238036	20.9%

Decimal Number

Value	Count	Frequency (%)
1	1	50.0%
4	1	50.0%

Space Separator

Value	Count	Frequency (%)
	89844	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	290	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	263	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1140982	92.7%
Common	90399	7.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	203082	17.8%
o	151991	13.3%
i	94150	8.3%
r	91236	8.0%
e	79953	7.0%
s	75446	6.6%
n	54566	4.8%
u	54064	4.7%
l	53676	4.7%
p	44782	3.9%
Other values (16)	238036	20.9%

Common

Value	Count	Frequency (%)
	89844	99.4%
-	290	0.3%
'	263	0.3%
1	1	< 0.1%
4	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1231381	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	203082	16.5%
o	151991	12.3%
i	94150	7.6%
r	91236	7.4%
	89844	7.3%
e	79953	6.5%
s	75446	6.1%
n	54566	4.4%
u	54064	4.4%
l	53676	4.4%
Other values (21)	283373	23.0%

customer_state
Categorical

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

SP	50265
RJ	15518
MG	13819
RS	6573
PR	6043
Other values (22)	26925

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	238286
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SP
2nd row	SP
3rd row	SP
4th row	SP
5th row	SP

Common Values

Value	Count	Frequency (%)
SP	50265	42.2%
RJ	15518	13.0%
MG	13819	11.6%
RS	6573	5.5%
PR	6043	5.1%
SC	4345	3.6%
BA	4091	3.4%
DF	2516	2.1%
GO	2466	2.1%
ES	2360	2.0%
Other values (17)	11147	9.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	50265	42.2%
rj	15518	13.0%
mg	13819	11.6%
rs	6573	5.5%
pr	6043	5.1%
sc	4345	3.6%
ba	4091	3.4%
df	2516	2.1%
go	2466	2.1%
es	2360	2.0%
Other values (17)	11147	9.4%

Most occurring characters

Value	Count	Frequency (%)
S	64808	27.2%
P	60647	25.5%
R	29104	12.2%
M	16842	7.1%
G	16285	6.8%
J	15518	6.5%
A	6892	2.9%
E	6234	2.6%
C	6005	2.5%
B	4735	2.0%
Other values (7)	11216	4.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	238286	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	64808	27.2%
P	60647	25.5%
R	29104	12.2%
M	16842	7.1%
G	16285	6.8%
J	15518	6.5%
A	6892	2.9%
E	6234	2.6%
C	6005	2.5%
B	4735	2.0%
Other values (7)	11216	4.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	238286	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	64808	27.2%
P	60647	25.5%
R	29104	12.2%
M	16842	7.1%
G	16285	6.8%
J	15518	6.5%
A	6892	2.9%
E	6234	2.6%
C	6005	2.5%
B	4735	2.0%
Other values (7)	11216	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	238286	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	64808	27.2%
P	60647	25.5%
R	29104	12.2%
M	16842	7.1%
G	16285	6.8%
J	15518	6.5%
A	6892	2.9%
E	6234	2.6%
C	6005	2.5%
B	4735	2.0%
Other values (7)	11216	4.7%

product_description_lenght
Real number (ℝ)

Distinct	2961
Distinct (%)	2.5%
Missing	833
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	774.61444

Minimum	0
Maximum	3992
Zeros	1709
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	135
Q1	340
median	594
Q3	977
95-th percentile	2113
Maximum	3992
Range	3992
Interquartile range (IQR)	637

Descriptive statistics

Standard deviation	654.60589
Coefficient of variation (CV)	0.84507319
Kurtosis	4.8856742
Mean	774.61444
Median Absolute Deviation (MAD)	299
Skewness	1.9918057
Sum	91644634
Variance	428508.87
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1709	1.4%
341	711	0.6%
1893	667	0.6%
348	648	0.5%
903	594	0.5%
492	594	0.5%
245	587	0.5%
366	537	0.5%
236	516	0.4%
340	487	0.4%
Other values (2951)	111260	93.4%
(Missing)	833	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1709	1.4%
4	6	< 0.1%
8	2	< 0.1%
15	1	< 0.1%
20	7	< 0.1%
23	1	< 0.1%
26	2	< 0.1%
27	4	< 0.1%
28	2	< 0.1%
30	8	< 0.1%

Value	Count	Frequency (%)
3992	2	< 0.1%
3988	1	< 0.1%
3985	3	< 0.1%
3976	6	< 0.1%
3963	1	< 0.1%
3956	3	< 0.1%
3954	2	< 0.1%
3950	2	< 0.1%
3949	1	< 0.1%
3948	1	< 0.1%

product_photos_qty
Real number (ℝ)

Distinct	20
Distinct (%)	< 0.1%
Missing	833
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	2.1733074

Minimum	0
Maximum	20
Zeros	1709
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	3
95-th percentile	6
Maximum	20
Range	20
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.7251844
Coefficient of variation (CV)	0.79380599
Kurtosis	4.7453186
Mean	2.1733074
Median Absolute Deviation (MAD)	1
Skewness	1.8812261
Sum	257124
Variance	2.9762614
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
1	58957	49.5%
2	23054	19.3%
3	12978	10.9%
4	8863	7.4%
5	5599	4.7%
6	3945	3.3%
0	1709	1.4%
7	1560	1.3%
8	774	0.6%
10	354	0.3%
Other values (10)	517	0.4%
(Missing)	833	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1709	1.4%
1	58957	49.5%
2	23054	19.3%
3	12978	10.9%
4	8863	7.4%
5	5599	4.7%
6	3945	3.3%
7	1560	1.3%
8	774	0.6%
9	318	0.3%

Value	Count	Frequency (%)
20	1	< 0.1%
19	2	< 0.1%
18	4	< 0.1%
17	11	< 0.1%
15	12	< 0.1%
14	6	< 0.1%
13	30	< 0.1%
12	60	0.1%
11	73	0.1%
10	354	0.3%

product_weight_g
Real number (ℝ)

Distinct	2204
Distinct (%)	1.9%
Missing	853
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	2112.2507

Minimum	0
Maximum	40425
Zeros	8
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	0
5-th percentile	125
Q1	300
median	700
Q3	1800
95-th percentile	9850
Maximum	40425
Range	40425
Interquartile range (IQR)	1500

Descriptive statistics

Standard deviation	3786.6951
Coefficient of variation (CV)	1.7927299
Kurtosis	16.01826
Mean	2112.2507
Median Absolute Deviation (MAD)	500
Skewness	3.5830918
Sum	2.4985814 × 10⁸
Variance	14339060
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	7093	6.0%
150	5410	4.5%
250	4741	4.0%
300	4429	3.7%
400	3787	3.2%
100	3666	3.1%
350	3291	2.8%
500	2856	2.4%
600	2838	2.4%
700	2148	1.8%
Other values (2194)	78031	65.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8	< 0.1%
2	5	< 0.1%
25	3	< 0.1%
50	991	0.8%
53	2	< 0.1%
54	2	< 0.1%
55	2	< 0.1%
58	1	< 0.1%
60	9	< 0.1%
61	5	< 0.1%

Value	Count	Frequency (%)
40425	3	< 0.1%
30000	303	0.3%
29800	1	< 0.1%
29750	1	< 0.1%
29700	4	< 0.1%
29600	5	< 0.1%
29500	2	< 0.1%
29250	1	< 0.1%
29150	1	< 0.1%
29100	1	< 0.1%

product_length_cm
Real number (ℝ)

Distinct	99
Distinct (%)	0.1%
Missing	853
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	30.265145

Minimum	7
Maximum	105
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	7
5-th percentile	16
Q1	18
median	25
Q3	38
95-th percentile	62
Maximum	105
Range	98
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	16.189367
Coefficient of variation (CV)	0.53491788
Kurtosis	3.6785662
Mean	30.265145
Median Absolute Deviation (MAD)	8
Skewness	1.7456849
Sum	3580064
Variance	262.09561
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	18363	15.4%
20	10999	9.2%
30	7951	6.7%
17	6202	5.2%
18	5909	5.0%
19	4898	4.1%
25	4871	4.1%
40	4360	3.7%
22	4000	3.4%
50	3163	2.7%
Other values (89)	47574	39.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7	32	< 0.1%
8	2	< 0.1%
9	4	< 0.1%
10	8	< 0.1%
11	96	0.1%
12	41	< 0.1%
13	60	0.1%
14	138	0.1%
15	220	0.2%
16	18363	15.4%

Value	Count	Frequency (%)
105	335	0.3%
104	35	< 0.1%
103	46	< 0.1%
102	60	0.1%
101	108	0.1%
100	429	0.4%
99	36	< 0.1%
98	50	< 0.1%
97	11	< 0.1%
96	8	< 0.1%

product_height_cm
Real number (ℝ)

Distinct	102
Distinct (%)	0.1%
Missing	853
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	16.619706

Minimum	2
Maximum	105
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	8
median	13
Q3	20
95-th percentile	45
Maximum	105
Range	103
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	13.453584
Coefficient of variation (CV)	0.80949592
Kurtosis	7.2778781
Mean	16.619706
Median Absolute Deviation (MAD)	6
Skewness	2.2389625
Sum	1965945
Variance	180.99892
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	10374	8.7%
20	6915	5.8%
15	6896	5.8%
12	6520	5.5%
11	6432	5.4%
2	5254	4.4%
4	4910	4.1%
8	4873	4.1%
5	4776	4.0%
16	4765	4.0%
Other values (92)	56575	47.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	5254	4.4%
3	2821	2.4%
4	4910	4.1%
5	4776	4.0%
6	3576	3.0%
7	4387	3.7%
8	4873	4.1%
9	3408	2.9%
10	10374	8.7%
11	6432	5.4%

Value	Count	Frequency (%)
105	139	0.1%
104	14	< 0.1%
103	49	< 0.1%
102	10	< 0.1%
100	43	< 0.1%
99	5	< 0.1%
98	3	< 0.1%
97	2	< 0.1%
96	8	< 0.1%
95	22	< 0.1%

product_width_cm
Real number (ℝ)

Distinct	95
Distinct (%)	0.1%
Missing	853
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	23.074799

Minimum	6
Maximum	118
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.8 MiB

Quantile statistics

Minimum	6
5-th percentile	11
Q1	15
median	20
Q3	30
95-th percentile	45
Maximum	118
Range	112
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	11.749139
Coefficient of variation (CV)	0.50917622
Kurtosis	4.5530162
Mean	23.074799
Median Absolute Deviation (MAD)	6
Skewness	1.707171
Sum	2729518
Variance	138.04227
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	12701	10.7%
11	11144	9.4%
15	9376	7.9%
16	8810	7.4%
30	8045	6.8%
12	5711	4.8%
13	5491	4.6%
14	4846	4.1%
18	4192	3.5%
40	4157	3.5%
Other values (85)	43817	36.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6	2	< 0.1%
7	5	< 0.1%
8	29	< 0.1%
9	51	< 0.1%
10	83	0.1%
11	11144	9.4%
12	5711	4.8%
13	5491	4.6%
14	4846	4.1%
15	9376	7.9%

Value	Count	Frequency (%)
118	8	< 0.1%
105	14	< 0.1%
104	1	< 0.1%
103	1	< 0.1%
102	2	< 0.1%
101	2	< 0.1%
100	43	< 0.1%
98	1	< 0.1%
97	1	< 0.1%
95	2	< 0.1%

product_category_name_english
Categorical

Distinct	72
Distinct (%)	0.1%
Missing	833
Missing (%)	0.7%
Memory size	1.8 MiB

bed_bath_table	11988
health_beauty	10032
sports_leisure	9004
furniture_decor	8832
computers_accessories	8150
Other values (67)	70304

Length

Max length	39
Median length	31
Mean length	12.900532
Min length	3

Characters and Unicode

Total characters	1526262
Distinct characters	25
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	housewares
2nd row	housewares
3rd row	housewares
4th row	housewares
5th row	housewares

Common Values

Value	Count	Frequency (%)
bed_bath_table	11988	10.1%
health_beauty	10032	8.4%
sports_leisure	9004	7.6%
furniture_decor	8832	7.4%
computers_accessories	8150	6.8%
housewares	7380	6.2%
watches_gifts	6213	5.2%
telephony	4726	4.0%
garden_tools	4590	3.9%
auto	4400	3.7%
Other values (62)	42995	36.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
bed_bath_table	11988	10.1%
health_beauty	10032	8.5%
sports_leisure	9004	7.6%
furniture_decor	8832	7.5%
computers_accessories	8150	6.9%
housewares	7380	6.2%
watches_gifts	6213	5.3%
telephony	4726	4.0%
garden_tools	4590	3.9%
auto	4400	3.7%
Other values (62)	42995	36.3%

Most occurring characters

Value	Count	Frequency (%)
e	185298	12.1%
s	142057	9.3%
t	133341	8.7%
o	113626	7.4%
r	105808	6.9%
a	102466	6.7%
_	102216	6.7%
u	79961	5.2%
c	72479	4.7%
i	63331	4.1%
Other values (15)	425679	27.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1423745	93.3%
Connector Punctuation	102216	6.7%
Decimal Number	301	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	185298	13.0%
s	142057	10.0%
t	133341	9.4%
o	113626	8.0%
r	105808	7.4%
a	102466	7.2%
u	79961	5.6%
c	72479	5.1%
i	63331	4.4%
h	59668	4.2%
Other values (13)	365710	25.7%

Connector Punctuation

Value	Count	Frequency (%)
_	102216	100.0%

Decimal Number

Value	Count	Frequency (%)
2	301	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1423745	93.3%
Common	102517	6.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	185298	13.0%
s	142057	10.0%
t	133341	9.4%
o	113626	8.0%
r	105808	7.4%
a	102466	7.2%
u	79961	5.6%
c	72479	5.1%
i	63331	4.4%
h	59668	4.2%
Other values (13)	365710	25.7%

Common

Value	Count	Frequency (%)
_	102216	99.7%
2	301	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1526262	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	185298	12.1%
s	142057	9.3%
t	133341	8.7%
o	113626	7.4%
r	105808	6.9%
a	102466	6.7%
_	102216	6.7%
u	79961	5.2%
c	72479	4.7%
i	63331	4.1%
Other values (15)	425679	27.9%

seller_city
Categorical

Distinct	611
Distinct (%)	0.5%
Missing	833
Missing (%)	0.7%
Memory size	1.8 MiB

sao paulo	29293
ibitinga	8373
curitiba	3161
santo andre	3149
sao jose do rio preto	2693
Other values (606)	71641

Length

Max length	40
Median length	31
Mean length	10.102451
Min length	2

Characters and Unicode

Total characters	1195221
Distinct characters	41
Distinct categories	9 ?
Distinct scripts	3 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	64 ?
Unique (%)	0.1%

Sample

1st row	maua
2nd row	maua
3rd row	maua
4th row	maua
5th row	maua

Common Values

Value	Count	Frequency (%)
sao paulo	29293	24.6%
ibitinga	8373	7.0%
curitiba	3161	2.7%
santo andre	3149	2.6%
sao jose do rio preto	2693	2.3%
belo horizonte	2688	2.3%
rio de janeiro	2535	2.1%
guarulhos	2456	2.1%
ribeirao preto	2374	2.0%
maringa	2292	1.9%
Other values (601)	59296	49.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sao	36362	17.9%
paulo	29574	14.5%
ibitinga	8373	4.1%
rio	5930	2.9%
do	5524	2.7%
preto	5518	2.7%
de	4192	2.1%
jose	4085	2.0%
santo	3270	1.6%
andre	3164	1.6%
Other values (640)	97267	47.9%

Most occurring characters

Value	Count	Frequency (%)
a	198772	16.6%
o	146215	12.2%
i	102111	8.5%
	85009	7.1%
r	78220	6.5%
s	76216	6.4%
e	64170	5.4%
u	62907	5.3%
p	58419	4.9%
l	56917	4.8%
Other values (31)	266265	22.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1108993	92.8%
Space Separator	85009	7.1%
Other Punctuation	614	0.1%
Modifier Symbol	369	< 0.1%
Dash Punctuation	164	< 0.1%
Close Punctuation	31	< 0.1%
Open Punctuation	31	< 0.1%
Decimal Number	8	< 0.1%
Nonspacing Mark	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	198772	17.9%
o	146215	13.2%
i	102111	9.2%
r	78220	7.1%
s	76216	6.9%
e	64170	5.8%
u	62907	5.7%
p	58419	5.3%
l	56917	5.1%
t	47317	4.3%
Other values (14)	217729	19.6%

Other Punctuation

Value	Count	Frequency (%)
'	347	56.5%
/	141	23.0%
.	76	12.4%
@	38	6.2%
\	6	1.0%
,	6	1.0%

Decimal Number

Value	Count	Frequency (%)
4	2	25.0%
2	2	25.0%
5	2	25.0%
0	1	12.5%
8	1	12.5%

Space Separator

Value	Count	Frequency (%)
	85009	100.0%

Modifier Symbol

Value	Count	Frequency (%)
´	369	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	164	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	31	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	31	100.0%

Nonspacing Mark

Value	Count	Frequency (%)
̃	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1108993	92.8%
Common	86226	7.2%
Inherited	2	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	198772	17.9%
o	146215	13.2%
i	102111	9.2%
r	78220	7.1%
s	76216	6.9%
e	64170	5.8%
u	62907	5.7%
p	58419	5.3%
l	56917	5.1%
t	47317	4.3%
Other values (14)	217729	19.6%

Common

Value	Count	Frequency (%)
	85009	98.6%
´	369	0.4%
'	347	0.4%
-	164	0.2%
/	141	0.2%
.	76	0.1%
@	38	< 0.1%
)	31	< 0.1%
(	31	< 0.1%
\	6	< 0.1%
Other values (6)	14	< 0.1%

Inherited

Value	Count	Frequency (%)
̃	2	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1194850	> 99.9%
None	369	< 0.1%
Diacriticals	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	198772	16.6%
o	146215	12.2%
i	102111	8.5%
	85009	7.1%
r	78220	6.5%
s	76216	6.4%
e	64170	5.4%
u	62907	5.3%
p	58419	4.9%
l	56917	4.8%
Other values (29)	265894	22.3%

None

Value	Count	Frequency (%)
´	369	100.0%

Diacriticals

Value	Count	Frequency (%)
̃	2	100.0%

seller_state
Categorical

Distinct	23
Distinct (%)	< 0.1%
Missing	833
Missing (%)	0.7%
Memory size	1.8 MiB

SP	84377
MG	9314
PR	9096
RJ	5036
SC	4271
Other values (18)	6216

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	236620
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	SP
2nd row	SP
3rd row	SP
4th row	SP
5th row	SP

Common Values

Value	Count	Frequency (%)
SP	84377	70.8%
MG	9314	7.8%
PR	9096	7.6%
RJ	5036	4.2%
SC	4271	3.6%
RS	2294	1.9%
DF	949	0.8%
BA	700	0.6%
GO	550	0.5%
PE	465	0.4%
Other values (13)	1258	1.1%
(Missing)	833	0.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	84377	71.3%
mg	9314	7.9%
pr	9096	7.7%
rj	5036	4.3%
sc	4271	3.6%
rs	2294	1.9%
df	949	0.8%
ba	700	0.6%
go	550	0.5%
pe	465	0.4%
Other values (13)	1258	1.1%

Most occurring characters

Value	Count	Frequency (%)
P	94002	39.7%
S	91402	38.6%
R	16496	7.0%
M	9934	4.2%
G	9864	4.2%
J	5036	2.1%
C	4375	1.8%
A	1122	0.5%
E	968	0.4%
D	949	0.4%
Other values (6)	2472	1.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	236620	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	94002	39.7%
S	91402	38.6%
R	16496	7.0%
M	9934	4.2%
G	9864	4.2%
J	5036	2.1%
C	4375	1.8%
A	1122	0.5%
E	968	0.4%
D	949	0.4%
Other values (6)	2472	1.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	236620	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	94002	39.7%
S	91402	38.6%
R	16496	7.0%
M	9934	4.2%
G	9864	4.2%
J	5036	2.1%
C	4375	1.8%
A	1122	0.5%
E	968	0.4%
D	949	0.4%
Other values (6)	2472	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	236620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	94002	39.7%
S	91402	38.6%
R	16496	7.0%
M	9934	4.2%
G	9864	4.2%
J	5036	2.1%
C	4375	1.8%
A	1122	0.5%
E	968	0.4%
D	949	0.4%
Other values (6)	2472	1.0%

Auto

Heatmap
Table

	length_comment_title	length_comment_message	payment_installments	payment_value	price	freight_value	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	order_status	review_score	payment_type	customer_state	product_category_name_english	seller_state
length_comment_title	1.000	0.312	0.010	0.043	0.017	0.045	0.029	0.005	-0.010	-0.032	0.002	-0.016	0.021	0.082	0.029	0.016	0.038	0.023
length_comment_message	0.312	1.000	0.048	0.083	0.029	0.036	-0.010	-0.009	0.037	0.010	0.024	0.016	0.044	0.216	0.009	0.025	0.027	0.013
payment_installments	0.010	0.048	1.000	0.395	0.315	0.191	0.034	0.000	0.198	0.109	0.106	0.125	0.005	0.027	0.236	0.032	0.088	0.033
payment_value	0.043	0.083	0.395	1.000	0.789	0.423	0.167	-0.008	0.449	0.229	0.305	0.232	0.015	0.028	0.018	0.029	0.136	0.036
price	0.017	0.029	0.315	0.789	1.000	0.433	0.206	0.030	0.514	0.266	0.327	0.271	0.014	0.012	0.014	0.020	0.114	0.052
freight_value	0.045	0.036	0.191	0.423	0.433	1.000	0.119	0.017	0.448	0.284	0.284	0.275	0.015	0.015	0.009	0.085	0.095	0.048
product_description_lenght	0.029	-0.010	0.034	0.167	0.206	0.119	1.000	0.152	0.096	-0.014	0.135	-0.070	0.016	0.015	0.021	0.026	0.212	0.112
product_photos_qty	0.005	-0.009	0.000	-0.008	0.030	0.017	0.152	1.000	0.008	0.012	-0.072	-0.006	0.012	0.016	0.005	0.014	0.154	0.040
product_weight_g	-0.010	0.037	0.198	0.449	0.514	0.448	0.096	0.008	1.000	0.619	0.532	0.621	0.011	0.020	0.018	0.028	0.199	0.078
product_length_cm	-0.032	0.010	0.109	0.229	0.266	0.284	-0.014	0.012	0.619	1.000	0.248	0.632	0.014	0.018	0.022	0.017	0.258	0.084
product_height_cm	0.002	0.024	0.106	0.305	0.327	0.284	0.135	-0.072	0.532	0.248	1.000	0.338	0.016	0.018	0.015	0.019	0.278	0.065
product_width_cm	-0.016	0.016	0.125	0.232	0.271	0.275	-0.070	-0.006	0.621	0.632	0.338	1.000	0.004	0.014	0.020	0.016	0.291	0.057
order_status	0.021	0.044	0.005	0.015	0.014	0.015	0.016	0.012	0.011	0.014	0.016	0.004	1.000	0.149	0.037	0.026	0.030	0.029
review_score	0.082	0.216	0.027	0.028	0.012	0.015	0.015	0.016	0.020	0.018	0.018	0.014	0.149	1.000	0.010	0.048	0.054	0.023
payment_type	0.029	0.009	0.236	0.018	0.014	0.009	0.021	0.005	0.018	0.022	0.015	0.020	0.037	0.010	1.000	0.033	0.059	0.021
customer_state	0.016	0.025	0.032	0.029	0.020	0.085	0.026	0.014	0.028	0.017	0.019	0.016	0.026	0.048	0.033	1.000	0.037	0.053
product_category_name_english	0.038	0.027	0.088	0.136	0.114	0.095	0.212	0.154	0.199	0.258	0.278	0.291	0.030	0.054	0.059	0.037	1.000	0.176
seller_state	0.023	0.013	0.033	0.036	0.052	0.048	0.112	0.040	0.078	0.084	0.065	0.057	0.029	0.023	0.021	0.053	0.176	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	order_status	order_purchase_timestamp	order_approved_at	order_delivered_carrier_date	order_delivered_customer_date	order_estimated_delivery_date	review_score	review_creation_date	review_answer_timestamp	length_comment_message	payment_type	payment_installments	payment_value	shipping_limit_date	price	freight_value	customer_city	customer_state	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	product_category_name_english	seller_city	seller_state
0	delivered	2017-10-02 10:56:33	2017-10-02 11:07:15	2017-10-04 19:55:00	2017-10-10 21:25:13	2017-10-18 00:00:00	4.0	2017-10-11 00:00:00	2017-10-12 03:43:48	170.0	credit_card	1.0	18.12	2017-10-06 11:07:15	29.99	8.72	sao paulo	SP	268.0	4.0	500.0	19.0	8.0	13.0	housewares	maua	SP
1	delivered	2017-10-02 10:56:33	2017-10-02 11:07:15	2017-10-04 19:55:00	2017-10-10 21:25:13	2017-10-18 00:00:00	4.0	2017-10-11 00:00:00	2017-10-12 03:43:48	170.0	voucher	1.0	2.00	2017-10-06 11:07:15	29.99	8.72	sao paulo	SP	268.0	4.0	500.0	19.0	8.0	13.0	housewares	maua	SP
2	delivered	2017-10-02 10:56:33	2017-10-02 11:07:15	2017-10-04 19:55:00	2017-10-10 21:25:13	2017-10-18 00:00:00	4.0	2017-10-11 00:00:00	2017-10-12 03:43:48	170.0	voucher	1.0	18.59	2017-10-06 11:07:15	29.99	8.72	sao paulo	SP	268.0	4.0	500.0	19.0	8.0	13.0	housewares	maua	SP
3	delivered	2017-08-15 18:29:31	2017-08-15 20:05:16	2017-08-17 15:28:33	2017-08-18 14:44:43	2017-08-28 00:00:00	4.0	2017-08-19 00:00:00	2017-08-20 15:16:36	84.0	credit_card	3.0	37.77	2017-08-21 20:05:16	29.99	7.78	sao paulo	SP	268.0	4.0	500.0	19.0	8.0	13.0	housewares	maua	SP
4	delivered	2017-08-02 18:24:47	2017-08-02 18:43:15	2017-08-04 17:35:43	2017-08-07 18:30:01	2017-08-15 00:00:00	5.0	2017-08-08 00:00:00	2017-08-08 23:26:23	60.0	credit_card	1.0	37.77	2017-08-08 18:37:31	29.99	7.78	sao paulo	SP	268.0	4.0	500.0	19.0	8.0	13.0	housewares	maua	SP
5	delivered	2017-10-23 23:26:46	2017-10-25 02:14:11	2017-10-27 16:48:46	2017-11-07 18:04:59	2017-11-13 00:00:00	3.0	2017-11-08 00:00:00	2017-11-10 19:52:38	0.0	boleto	1.0	44.09	2017-10-31 02:14:11	29.99	14.10	florianopolis	SC	268.0	4.0	500.0	19.0	8.0	13.0	housewares	maua	SP
6	delivered	2017-08-10 13:35:55	2017-08-10 13:50:09	2017-08-11 13:52:35	2017-08-16 19:03:36	2017-08-23 00:00:00	5.0	2017-08-17 00:00:00	2017-08-21 12:43:27	41.0	credit_card	1.0	83.69	2017-08-16 13:50:09	75.90	7.79	itaquaquecetuba	SP	398.0	3.0	238.0	20.0	10.0	15.0	baby	maua	SP
7	delivered	2017-08-15 02:03:01	2017-08-15 02:15:13	2017-08-16 15:52:29	2017-08-25 21:59:26	2017-08-28 00:00:00	4.0	2017-08-26 00:00:00	2017-08-28 20:10:38	44.0	credit_card	2.0	83.69	2017-08-21 02:15:13	75.90	7.79	campinas	SP	398.0	3.0	238.0	20.0	10.0	15.0	baby	maua	SP
8	delivered	2017-08-01 16:31:35	2017-08-02 02:50:25	2017-08-03 14:36:34	2017-08-09 19:56:50	2017-08-23 00:00:00	5.0	2017-08-10 00:00:00	2017-08-11 21:08:38	0.0	boleto	1.0	90.18	2017-08-08 02:50:25	75.90	14.28	curitiba	PR	398.0	3.0	238.0	20.0	10.0	15.0	baby	maua	SP
9	delivered	2017-08-10 14:04:58	2017-08-10 14:23:38	2017-08-11 13:52:35	2017-08-12 11:56:49	2017-08-23 00:00:00	2.0	2017-08-13 00:00:00	2017-08-14 12:24:58	84.0	credit_card	2.0	83.69	2017-08-16 14:23:38	75.90	7.79	campinas	SP	398.0	3.0	238.0	20.0	10.0	15.0	baby	maua	SP

	order_status	order_purchase_timestamp	order_approved_at	order_delivered_carrier_date	order_delivered_customer_date	order_estimated_delivery_date	review_score	review_creation_date	review_answer_timestamp	payment_type	payment_installments	payment_value	shipping_limit_date	price	freight_value	customer_city	customer_state	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	product_category_name_english	seller_city	seller_state
119133	canceled	2018-03-01 11:42:23	2018-03-01 12:20:32	NaN	NaN	2018-03-20 00:00:00	1.0	2018-03-22 00:00:00	2018-03-26 03:00:14	credit_card	2.0	102.09	2018-03-08 12:20:32	79.90	22.19	americana	SP	87.0	1.0	3500.0	20.0	20.0	20.0	furniture_decor	pirassununga	SP
119134	delivered	2018-08-10 21:14:35	2018-08-10 21:25:22	2018-08-13 13:54:00	2018-08-21 04:16:31	2018-08-30 00:00:00	5.0	2018-08-21 00:00:00	2018-08-21 22:01:55	credit_card	2.0	134.48	2018-08-15 21:25:22	44.99	22.25	carai	MG	645.0	2.0	600.0	30.0	20.0	20.0	sports_leisure	paulo lopes	SC
119135	delivered	2018-08-10 21:14:35	2018-08-10 21:25:22	2018-08-13 13:54:00	2018-08-21 04:16:31	2018-08-30 00:00:00	5.0	2018-08-21 00:00:00	2018-08-21 22:01:55	credit_card	2.0	134.48	2018-08-15 21:25:22	44.99	22.25	carai	MG	645.0	2.0	600.0	30.0	20.0	20.0	sports_leisure	paulo lopes	SC
119136	canceled	2018-03-13 10:58:09	2018-03-14 03:08:35	NaN	NaN	2018-03-23 00:00:00	5.0	2018-03-28 00:00:00	2018-03-28 18:11:45	boleto	1.0	321.34	2018-03-20 03:08:35	149.00	11.67	taboao da serra	SP	682.0	1.0	1700.0	30.0	5.0	30.0	garden_tools	sao paulo	SP
119137	canceled	2018-03-13 10:58:09	2018-03-14 03:08:35	NaN	NaN	2018-03-23 00:00:00	5.0	2018-03-28 00:00:00	2018-03-28 18:11:45	boleto	1.0	321.34	2018-03-20 03:08:35	149.00	11.67	taboao da serra	SP	682.0	1.0	1700.0	30.0	5.0	30.0	garden_tools	sao paulo	SP
119138	delivered	2018-07-01 10:23:10	2018-07-05 16:17:52	2018-07-04 14:34:00	2018-07-09 15:06:57	2018-07-20 00:00:00	5.0	2018-07-10 00:00:00	2018-07-10 18:32:29	boleto	1.0	93.13	2018-07-10 08:32:33	79.00	14.13	ferraz de vasconcelos	SP	516.0	2.0	750.0	30.0	28.0	28.0	construction_tools_lights	porto ferreira	SP
119139	canceled	2017-03-11 19:51:36	2017-03-11 19:51:36	NaN	NaN	2017-03-30 00:00:00	1.0	2017-04-01 00:00:00	2017-04-01 10:24:03	credit_card	1.0	30.66	2017-03-16 19:51:36	19.70	10.96	gaspar	SC	260.0	2.0	400.0	16.0	4.0	11.0	auto	blumenau	SC
119140	delivered	2018-07-24 09:46:27	2018-07-24 11:24:27	2018-07-24 15:14:00	2018-08-02 22:47:35	2018-08-16 00:00:00	5.0	2018-08-03 00:00:00	2018-08-04 11:22:40	debit_card	1.0	444.07	2018-07-30 11:24:27	399.00	45.07	fortaleza	CE	729.0	2.0	2100.0	80.0	8.0	30.0	furniture_decor	americana	SP
119141	delivered	2018-05-22 21:13:21	2018-05-22 21:35:40	2018-05-24 12:28:00	2018-06-12 23:11:29	2018-06-08 00:00:00	4.0	2018-06-10 00:00:00	2018-06-13 09:17:47	credit_card	4.0	244.02	2018-05-28 21:31:24	219.90	24.12	teofilo otoni	MG	531.0	1.0	5900.0	41.0	21.0	41.0	furniture_decor	sao paulo	SP
119142	delivered	2018-05-15 17:41:00	2018-05-16 03:35:29	2018-05-16 17:20:00	2018-05-21 14:31:41	2018-05-29 00:00:00	5.0	2018-06-01 00:00:00	2018-06-01 15:14:23	boleto	1.0	28.29	2018-05-22 03:35:29	15.50	12.79	sao bernardo do campo	SP	871.0	1.0	83.0	17.0	8.0	13.0	perfumery	ribeirao preto	SP

Most frequently occurring

	order_status	order_purchase_timestamp	order_approved_at	order_delivered_carrier_date	order_delivered_customer_date	order_estimated_delivery_date	review_score	review_creation_date	review_answer_timestamp	length_comment_title	length_comment_message	payment_type	payment_installments	payment_value	shipping_limit_date	price	freight_value	customer_city	customer_state	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	product_category_name_english	seller_city	seller_state	# duplicates
1698	delivered	2017-08-23 09:22:34	2017-08-24 14:30:23	2017-08-25 20:07:36	2017-09-02 12:13:03	2017-09-21 00:00:00	NaN	NaN	NaN	NaN	NaN	credit_card	4.0	2262.80	2017-08-30 14:30:23	98.70	14.44	goiania	GO	1042.0	1.0	1400.0	20.0	31.0	30.0	auto	sao paulo	SP	20
4451	delivered	2018-02-22 15:30:41	2018-02-24 03:20:27	2018-03-02 00:18:01	2018-03-05 15:22:27	2018-03-08 00:00:00	1.0	2018-03-06 00:00:00	2018-03-12 12:46:07	0.0	0.0	boleto	1.0	2202.40	2018-03-01 02:50:48	100.00	10.12	sao paulo	SP	452.0	1.0	360.0	19.0	18.0	15.0	computers_accessories	sao jose dos campos	SP	20
6487	delivered	2018-06-12 00:22:18	2018-06-12 01:35:10	2018-06-13 14:13:00	2018-06-14 14:58:59	2018-06-21 00:00:00	4.0	2018-06-15 00:00:00	2018-06-15 19:25:55	0.0	0.0	voucher	1.0	15.48	2018-06-18 01:30:50	29.00	7.94	paulinia	SP	383.0	1.0	100.0	20.0	15.0	12.0	sports_leisure	amparo	SP	18
1542	delivered	2017-08-08 20:26:31	2017-08-08 20:43:31	2017-08-10 11:58:14	2017-08-14 12:46:18	2017-08-30 00:00:00	5.0	2017-08-15 00:00:00	2017-08-17 22:17:55	0.0	0.0	voucher	1.0	16.70	2017-08-14 20:43:31	12.99	23.21	sao paulo	SP	86.0	2.0	1300.0	50.0	9.0	41.0	bed_bath_table	tres rios	RJ	16
136	delivered	2017-01-30 21:44:49	2017-01-30 22:33:45	2017-02-01 14:34:10	2017-02-14 10:48:10	2017-03-07 00:00:00	5.0	2017-02-15 00:00:00	2017-02-16 17:14:41	0.0	0.0	credit_card	10.0	783.00	2017-02-03 21:44:49	51.00	1.20	goiania	GO	369.0	2.0	600.0	38.0	16.0	25.0	garden_tools	jaragua do sul	SC	15
2851	delivered	2017-11-23 20:30:52	2017-11-24 10:31:10	2017-11-28 16:42:21	2017-12-13 20:19:35	2017-12-19 00:00:00	5.0	2017-12-14 00:00:00	2017-12-19 14:14:16	0.0	0.0	credit_card	10.0	1225.65	2017-11-30 10:30:51	65.49	16.22	uniao da vitoria	PR	1744.0	2.0	700.0	62.0	15.0	15.0	furniture_decor	fernandopolis	SP	15
903	delivered	2017-05-29 14:06:33	2017-05-29 14:25:14	2017-05-30 09:25:02	2017-06-01 15:34:09	2017-06-09 00:00:00	5.0	2017-06-02 00:00:00	2017-06-03 17:09:01	0.0	0.0	voucher	1.0	50.00	2017-06-02 14:25:14	723.74	17.02	sao paulo	SP	2396.0	2.0	3600.0	36.0	10.0	23.0	musical_instruments	braganca paulista	SP	14
1539	delivered	2017-08-08 20:26:31	2017-08-08 20:43:31	2017-08-10 11:58:14	2017-08-14 12:46:18	2017-08-30 00:00:00	5.0	2017-08-15 00:00:00	2017-08-17 22:17:55	0.0	0.0	voucher	1.0	2.61	2017-08-14 20:43:31	12.99	23.21	sao paulo	SP	86.0	2.0	1300.0	50.0	9.0	41.0	bed_bath_table	tres rios	RJ	14
3372	delivered	2017-12-13 14:21:15	2017-12-15 02:30:41	2017-12-15 18:45:18	2017-12-28 09:05:34	2018-01-08 00:00:00	1.0	2017-12-29 00:00:00	2017-12-31 12:08:24	0.0	0.0	boleto	1.0	1014.02	2017-12-21 02:30:41	59.00	13.43	santos	SP	348.0	2.0	1550.0	30.0	22.0	30.0	garden_tools	sao jose do rio preto	SP	14
4412	delivered	2018-02-21 11:45:07	2018-02-22 11:48:42	2018-02-27 18:27:01	2018-03-01 20:47:01	2018-03-07 00:00:00	1.0	2018-03-02 00:00:00	2018-03-03 00:44:54	0.0	74.0	credit_card	6.0	528.78	2018-02-28 11:48:12	29.99	7.78	indaiatuba	SP	55.0	1.0	300.0	20.0	20.0	13.0	telephony	santo andre	SP	14

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category